Why is the `remove rows` button not always present in MySQL Workbench?

Posted by Shawn on Super User See other posts from Super User or by Shawn
Published on 2012-09-12T16:03:06Z Indexed on 2012/09/25 15:40 UTC
Read the original article Hit count: 249

Filed under:

I'm using MySQL Workbench to remove rows from a table in my database. Most of the time, I will simply write a select statement, then select the rows I want to erase and use the remove rows button (circled in the screenshot below).

Usual result of a select statement

But sometimes (quite often actually), the remove rows button does not appear. Instead, I get something like the screenshot below:

Buggy result of a select statement

The remove rows button is not there and the remove rows option is grayed out in the context menu, so basically, I can't remove rows... The only way I've found of solving this issue is to run the select query many times until the button appears (it usually does after 3 of 4 times).

Does anyone know why this is happening?

UPDATE

Today, I've been running a select query dozens of times and the button never appears. It seems my incomprehensible workaround no longer works... Help!

btw: Using a delete statement does work, though I would rather not have to write one for each row I want to remove as this happens quite frequently during development...

© Super User or respective owner

Related posts about mysql-workbench